"""
@Time ： 2022/12/9 11:11
@Auth ： 陈杰 200320501042
@E-mail : 1612845322@qq.com
"""
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, String, DateTime, Float

Base = declarative_base()


class Student(Base):
    __tablename__ = "student"
    sid = Column(String(10), primary_key=True)
    sname = Column(String(8), nullable=False)
    sex = Column(String(2), nullable=False)
    birthday = Column(DateTime, nullable=False)
    specialty = Column(String(26), nullable=False)
    ascores = Column(Float, nullable=False)
